Previous Topic

Next Topic

Defining multiple values for a filter property

When a filter Property contains a discrete drop-down list of values, you can select a single value from the list or you can select a subset of multiple values. The selected values are used as an OR comparison.

Note: The Multiple checkbox is available only for properties that have a discrete drop-down list of values. If the property does not display the Multiple checkbox, you can still specify multiple values by entering a comma-delimited list of quoted values. For example, you could specify the following multiple values for a City property: "Austin","Houston","Dallas".

To define multiple values for a filter property

  1. Create or edit a query.
  2. Select the Filters tab.
  3. From the Mode drop-down list, choose Advanced.

    A Query Options section appears on the Filters tab.

  4. Next to Mode, choose Advanced from the drop-down menu.

    A new Multiple column appears between the Comparison and Value columns. For properties that have a discrete list of values, there will be a checkbox visible in the Multiple column.

  5. Select the Multiple checkbox.

    The drop-down list in the Value column is replaced by a larger, read-only field and a button.

  6. Click .

    A Select Values dialog appears.

  7. From the Available Values list, select the values that you want to use in the filter. You can multi-select values by holding Shift or Ctrl while selecting values with your mouse.
  8. Click >> to add the selected values to the Selected Values list.
  9. Click OK.

    The selected values appear in the read-only list in the Value column.

    Defining Multiple Filter Values

See Also

Adding a Filter

Tips for adding filters

Controlling Joins Between Filters

Entering Values for Comparison

Filter Options for Advanced Mode


ASI logo 10.6 Production Release. Updated 7/27/2006 3:52:59 PM
© Copyright by Advanced Solutions International, Inc. All rights reserved.